{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Get Creative"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Get Creative","index":0,"n_rows":48,"n_cols":17,"rows_kept":48,"cut":false,"hidden":false,"merged":[]}
["Operation Get Creative",{"$nulls":4},"DRAFT",null,"Created by SBAC Member"]
[]
["Inputs",{"$nulls":4},"Outputs"]
["Example Property Value",null,null,700000.0]
[{"$nulls":5},"Fiscal Year",2025.0,{"$f":"G5+1","v":2026},2027,2028,2029,2030,2031,2032,2033,2034,2035]
["School bond principle",null,null,1.145E8]
["Private fundraising to reduce bond size",null,null,5000000.0,null,"Property Value",{"$f":"D4","v":700000},{"$f":"G7*(1+$D$15)","v":700000},700000,700000,700000,700000,700000,700000,700000,700000,700000]
["Add'l fundraising to reduce peak inc by ~1%?",null,null,"Y",null,"Taxes, no bond",{"$f":"G7*G18/1000","v":7700},7968.159204,8245.657286,8532.81948,8829.982347,9137.49417,9455.71536,9785.01888,10125.79068,10478.43016,10843.35061]
["Fundraising to reduce peak Inc by ~1% more?",null,null,"Y",null,"Taxes, bond",{"$f":"G7*G19/1000","v":7700},8422.147495,9057.925499,9371.292413,9694.378972,10027.53596,10371.12575,10725.52324,11091.11684,11438.9537,11799.09542]
["Dedidated revenue stream for bond payment",null,null,500000.0,null,"% Inc over no bond",{"$f":"(G9-G8)/G8","v":0},0.05697530377,0.09850860702,0.09826446411,0.09789335818,0.0974054569,0.09681027382,0.09611676496,0.09533340995,0.09166674034,0.08814109648]
["2025 Town Budget",null,null,4.18E7,null,"Bond as % of taxes",null,{"$f":"(H9-H8)/H9","v":0.05390410123},0.08967486135,0.08947249713,0.08916472393,0.08875977086,0.08826528719,0.08768843615,0.08703597378,0.08396952747,0.08100153258]
["2025 Town Valuation",null,null,3.8E9,null,"YoY Tax Inc w/ bond",null,{"$f":"(H9-G9)/G9","v":0.09378538898},0.07548882327,0.03459588119,0.03447620076,0.03436599641,0.0342646279,0.03417155429,0.03408631803,0.03136175229,0.0314837999]
["YoY Operational Budget % Increase",null,null,0.04]
["YoY Town Assessment % Increase",null,null,0.005,null,"Town Valuation",{"$f":"D12","v":3800000000},{"$f":"G14*(1+$D$14)","v":3819000000},3838095000,3857285475,3876571902,3895954762,3915434536,3935011708,3954686767,3974460201,3994332502]
["YoY Property Assessment % Increase",null,null,0.0,null,"Town op budget",{"$f":"D11","v":41800000},{"$f":"G15*(1+$D$13)","v":43472000},45210880,47019315.2,48900087.81,50856091.32,52890334.97,55005948.37,57206186.31,59494433.76,61874211.11]
[{"$nulls":5},"Bond debt service",null,{"$f":"($H$46)-H22-H23-H26","v":2476830.406},{"$f":"($H$46*2)-I22-I23-I26","v":4453660.811},4620327.811,4786993.811,4953660.811,5120327.811,5286993.811,5453660.811,5453660.811,5453660.811]
[{"$nulls":5},"Total revenue",{"$f":"G15+G16","v":41800000},45948830.41,49664540.81,51639643.01,53687081.62,55809752.13,58010662.78,60292942.18,62659847.12,64948094.57,67327871.92]
[{"$nulls":5},"Mill rate, no bond",{"$f":"1000*G17/G14","v":11},{"$f":"1000*H15/H14","v":11.38308458},11.77951041,12.18974211,12.6142605,13.0535631,13.5081648,13.9785984,14.46541526,14.96918594,15.49050087]
[{"$nulls":5},"Mill rate, bond",{"$f":"1000*G17/G14","v":11},12.03163928,12.93989357,13.38756059,13.84911282,14.32505138,14.81589393,15.32217606,15.84445262,16.34136242,16.85585061]
[]
[{"$nulls":5},"Initial fundraising",null,{"$f":"D7","v":5000000}]
[{"$nulls":5},"Fundraising 1st%",null,null,{"$f":"IF(D8=\"Y\",500000,0)","v":500000},{"$f":"IF(D8=\"Y\",333333,0)","v":333333},{"$f":"IF(D8=\"Y\",166667,0)","v":166667}]
[{"$nulls":5},"Fundraising 2nd%",null,null,500000,{"$f":"IF(D9=\"Y\",500000,0)","v":500000},{"$f":"IF(D9=\"Y\",500000,0)","v":500000},{"$f":"IF(D9=\"Y\",500000,0)","v":500000},{"$f":"IF(D9=\"Y\",333333,0)","v":333333},{"$f":"IF(D9=\"Y\",166667,0)","v":166667}]
[{"$nulls":5},"Total Fundraising",null,{"$f":"SUM(H21:H23)","v":5000000},1000000,833333,666667,500000,333333,166667,0,0,0]
[]
[{"$nulls":5},"Dedicated revenue",null,{"$f":"$D$10","v":500000},{"$f":"H26","v":500000},500000,500000,500000,500000,500000,500000,500000,500000]
[]
[]
[{"$nulls":5},"Private Funds Total",{"$f":"SUM(G24:Q24)","v":8500000}]
{"$rows_empty":9}
["Debt Calculator"]
["Assumptions:"]
["Two bonds: Half starts repayment in 2026, Half starts in 2027"]
["School bond principle from Inputs above"]
[]
["Inputs",{"$nulls":4},"Outputs"]
["Annual interest rate",null,0.035,null,null,"Payment (1/2 P)",null,{"$f":"ABS(PMT(C45/C47,C46*C47,(D6-D7)/2))","v":2976830.406}]
["Loan term (years)",null,30.0,null,null,"Payment to count",null,{"$f":"H45*C48","v":2976830.406}]
["Payments per year",null,1.0]
["Payments to group",null,1.0]